<?php
class CourseController extends Zend_Controller_Action
{
    public function indexAction()
    {
        $query = Doctrine_Query::create()
            ->select('c.*, o.*')
            ->from('Course c')
            ->leftJoin('c.Content o')
            ->where('c.id = ?', $this->_getParam('id'));

        $result = $query->execute(array(), Doctrine::HYDRATE_ARRAY);
        print_r($result);
    }

    public function listAction()
    {
    }

    public function viewAction()
    {
        $query = Doctrine_Query::create()
            ->select('c.*, o.*')
            ->from('Course c, Content o')
            ->where('c.id = ?', $this->_getParam('id'));

        $result = $query->execute(array(), Doctrine::HYDRATE_ARRAY);
        print_r($result);
    }
}
?>